﻿CREATE TABLE [dbo].[FC_PriceCost] (
    [IdPriceCost] INT          IDENTITY (1, 1) NOT NULL,
    [IdEntityF]   INT          NULL,
    [IdProduct]   INT          NULL,
    [Value]       INT          NULL,
    [Currency]    VARCHAR (15) NULL,
    CONSTRAINT [PK_FC_PriceCost] PRIMARY KEY CLUSTERED ([IdPriceCost] ASC),
    CONSTRAINT [FK_FC_PriceCost_FC_Entity] FOREIGN KEY ([IdEntityF]) REFERENCES [dbo].[FC_Entity] ([IdEntityF]),
    CONSTRAINT [FK_FC_PriceCost_FC_Product] FOREIGN KEY ([IdProduct]) REFERENCES [dbo].[FC_Product] ([IdProduct])
);

